﻿# MySQL-Front 5.1  (Build 3.18)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: openshop
# ------------------------------------------------------
# Server version 5.1.35-community

#
# Source for table open_purchase_return_order_goods
#

DROP TABLE IF EXISTS `open_purchase_return_order_goods`;
CREATE TABLE `open_purchase_return_order_goods` (
  `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `color_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `size_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `norm_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `discount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `actual_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `norm_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `actual_mount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `goods_brief` tinytext NOT NULL,
  PRIMARY KEY (`rec_id`),
  UNIQUE KEY `spec_unique` (`order_id`,`goods_id`,`size_id`,`color_id`),
  KEY `goods_id` (`goods_id`),
  KEY `color_id` (`color_id`),
  KEY `size_id` (`size_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

#
# Dumping data for table open_purchase_return_order_goods
#
LOCK TABLES `open_purchase_return_order_goods` WRITE;
/*!40000 ALTER TABLE `open_purchase_return_order_goods` DISABLE KEYS */;

INSERT INTO `open_purchase_return_order_goods` VALUES (1,2,4146,793,319,2,2999,8,2399.2,5998,4798.4,'');
INSERT INTO `open_purchase_return_order_goods` VALUES (2,2,4146,793,308,1,2999,8,2399.2,2999,2399.2,'');
INSERT INTO `open_purchase_return_order_goods` VALUES (3,2,4179,798,326,1,249,8,199.2,249,199.2,'');
INSERT INTO `open_purchase_return_order_goods` VALUES (4,2,4179,798,310,1,249,8,199.2,249,199.2,'');
INSERT INTO `open_purchase_return_order_goods` VALUES (5,2,4170,854,326,2,149,8,119.2,298,238.4,'');
INSERT INTO `open_purchase_return_order_goods` VALUES (6,2,4170,854,310,3,149,8,119.2,447,357.6,'');
/*!40000 ALTER TABLE `open_purchase_return_order_goods` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
